Skip Headers

Pro*C/C++ Programmer's Guide 10g Release 2 (10.2) Part Number B14407-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# B Reserved Words, Keywords, and Namespaces

This appendix contains the following topics:

- Reserved Words and Keywords

- Oracle Reserved Namespaces

## Reserved Words and Keywords

Some words are reserved by Oracle. That is, they have a special meaning to Oracle and cannot be redefined. For this reason, you cannot use them to name database objects such as columns, tables, or indexes. To view the lists of the Oracle reserved words for SQL and PL/SQL, see the Oracle Database SQL Reference and the PL/SQL User's Guide and Reference.

Pro*C/C++ keywords, like C or C++ keywords, should not be used as variables in your program. Otherwise, an error will be generated. An error may result if they are used as the name of a database object such as a column. Here are the keywords used in Pro*C/C++:

Table B-1 Pro*C and C++ Keywords

Keywords | Keywords | Keywords | Keywords | Keywords
--- | --- | --- | --- | ---
all | allocate | alter | analyze | and
any | arraylen | as | asc | at
audit | authorization | avg | begin | between
bind | both | break | by | cache
call | cast | char | character | character
charf | charz | check | close | collection
comment | commit | connect | constraint | constraints
context | continue | convbufsz | count | create
current | currval | cursor | database | date
dateformat | datelang | day | deallocate | dec
decimal | declare | default | define | delete
deref | desc | describe | descriptor | display
distinct | do | double | drop | else
enable | end | endif | escape | exec
exec | execute | exists | explain | extract
fetch | float | flush | for | force
found | free | from | function | get
global | go | goto | grant | group
having | hour | iaf | identified | ifdef
ifndef | immediate | in | indicator | input
insert | integer | intersect | interval | into
is | is | leading | level | like
list | lob | local | lock | long
max | message | min | minus | minute
mode | month | multiset | nchar | nchar_cs
next | nextval | noaudit | not | notfound
nowait | null | number | numeric | nvarchar
nvarchar2 | object | ocibfilelocator | ocibloblocator | ocicloblocator
ocidate | ociextproccontext | ocinumber | ociraw | ocirowid
ocistring | of | only | open | option
option | or | oracle | order | output
overlaps | package | partition | precision | prepare
prior | procedure | put | raw | read
real | ref | reference | register | release
rename | replace | return | returning | revoke
role | rollback | rowid | rownum | savepoint
second | section | select | set | set
smallint | some | sql | sql_context | sql_cursor
sqlerror | sqlwarning | start | statement | stddev
stop | string | sum | sysdate | sysdba
sysoper | table | temporary | the | threads
time | timestamp | timezone_hour | timezone_minute | to
tools | trailing | transaction | trigger | trim
truncate | type | uid | ulong_varchar | union
unique | unsigned | update | use | user
using | uvarchar | validate | values | varchar
varchar | varchar2 | variables | variance | varnum
varraw | view | whenever | where | with
work | year | zone | - | -

## Oracle Reserved Namespaces

The following table contains a list of namespaces that are reserved by Oracle. The initial characters of function names in Oracle libraries are restricted to the character strings in this list. Because of potential name conflicts, do not use function names that begin with these characters. For example, the Oracle Net Transparent Network Service functions all begin with the characters `NS`, so you need to avoid naming functions that begin with `NS`.

Table B-2 Oracle Reserved Namespaces

Namespace | Library
--- | ---
XA | external functions for XA applications only
SQ | external SQLLIB functions used by Oracle Precompiler and SQL*Module applications
O, OCI | external OCI functions internal OCI functions
UPI, KP | function names from the Oracle UPI layer
NA NC ND NL NM NR NS NT NZ OSN TTC | Oracle Net Native services product Oracle Net RPC project Oracle Net Directory Oracle Net Network Library layer Oracle Net Net Management Project Oracle Net Interchange Oracle Net Transparent Network Service Oracle Net Drivers Oracle Net Security Service Oracle Net V1 Oracle Net Two task
GEN, L, ORA | Core library functions
LI, LM, LX | function names from the Oracle Globalization Support layer
S | function names from system-dependent libraries

The list in the table is not a comprehensive list of all functions within the Oracle reserved namespaces. For a complete list of functions within a particular namespace, refer to the document that corresponds to the appropriate Oracle library.